Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
AnnualIncomeRangeCode (PK) | Code that defines a high-low range of annual income for a consumer. | CD_ANN_INCM_RNGE | Code | varchar(20) | |
HighIncomeValue | High income value used to define a named annual income range for customer segmentation. | MO_HIGH_INCM_VL | Money | decimal(16,5) | |
LowIncomeValue | Low income value used to define a named annual income range for customer segmentation. | MO_LW_INCM_VL | Money | decimal(16,5) | |
CurrencyID (FK) | The unique identifier of the Currency. | ID_CNY | Identity | integer | Currency(CO_CNY) |
ISOCurrencyCode (FK) | Currency code designated by ISO to identify national currency | CD_CNY_ISO_4217 | ISO_4217_CurrencyCode_char(3) | char(3) | ISO4217-CurrencyType(LU_CNY_ISO_4217) |